On the accuracy of statistical procedures in Microsoft Excel 2003

نویسندگان

  • B. D. McCullough
  • Berry Wilson
چکیده

Some of the problems that rendered Excel 97, Excel 2000 and Excel 2002 unfit for use as a statistical package have been fixed in Excel 2003, though some have not. Additionally, in fixing some errors, Microsoft introduced other errors. Excel’s new and improved random number generator, at default, is supposed to produce uniform numbers on the interval (0,1); but it also produces negative numbers. Excel 2003 is an improvement over previous versions, but not enough has been done that its use for statistical purposes can be recommended. © 2004 Elsevier B.V. All rights reserved.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

On the accuracy of statistical procedures in Microsoft Excel 2007

Excel 2007, like its predecessors, fails a standard set of intermediate-level accuracy tests in three areas: statistical distributions, random number generation, and estimation. Additional errors in specific Excel procedures are discussed.Microsoft’s continuing inability to correctly fix errors is discussed. No statistical procedure in Excel should be used until Microsoft documents that the pro...

متن کامل

On the accuracy of statistical distributions in Microsoft Excel 2003

Some of previously indicated errors in Microsoft Excel 97 and Excel XP have been eliminated in Excel 2003. But some others have not been corrected in Excel 2003 and new ones have been found as is shown by numerical examples.

متن کامل

The accuracy of statistical distributions in Microsoft® Excel 2007

We provide an assessment of the statistical distributions in Microsoft r © Excel versions 97 through 2007 along with two competing spreadsheet programs, namely Gnumeric 1.7.11 and OpenOffice.org Calc 2.3.0. We find that the accuracy of various statistical functions in Excel 2007 range from unacceptably bad to acceptable but significantly inferior in comparison to alternative implementations. In...

متن کامل

Polynomial Trendline function flaws in Microsoft Excel

Numerous statistical and graphical problems have been reported for different versions of Microsoft Excel, including the newest version (Excel 2007). We report newly discovered problemswith Excel 2007when generating polynomial trend line equations, having a userspecified (forced) intercept, from graphed data. We also remind users of Excel’s Trendline function of problems with Excel 2003 that hav...

متن کامل

Tutorial Review: Simulation of Oscillating Chemical Reactions Using Microsoft Excel Macros

Oscillating reactions are one of the most interesting topics in chemistry and analytical chemistry. Fluctuations in concentrations of one the reacting species (usually a reaction intermediate) create an oscillating chemical reaction. In oscillating systems, the reaction is far from thermodynamic equilibrium. In these systems, at least one autocatalytic step is required. Developing an instinctiv...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:
  • Computational Statistics & Data Analysis

دوره 49  شماره 

صفحات  -

تاریخ انتشار 2005